﻿<!DOCTYPE html>
<html>
<head>
    <title>Scale a worksheet</title>
    <meta charset="utf-8" />
    <meta name="description" content="Scale to fit" />
    <link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
    <link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
    <script type="text/javascript" src="../callback.js"></script>
    <script type="text/javascript" src="../search/js/page-search.js"></script>
</head>
<body>
    <div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
        <h1>Scale a worksheet</h1>
        <p>If you want to fit an entire spreadsheet on one page to print it, you can use the <b>Scale to Fit</b> function. This function of the <a href="https://www.onlyoffice.com/en/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> helps scale data on the specified number of pages.</p>
        <p>To do so, follow these simple steps:</p>
        <ul>
            <li>on the <b>top toolbar</b>, enter the <b>Layout</b> tab and select the <div class = "icon icon-scaletofit"></div> <b>Scale to fit</b> function,
                <ul>
                    <li>in the <b>Height</b> section select <b>1 page</b> and set <b>Width</b> on <b>Auto</b> to print all sheets on one page. The scale value will be changed automatically. This value is displayed in the <b>Scale</b> section;</li>
                    <li>you can also change the scale value manually. To do this, set the <b>Height</b> and <b>Width</b> parameters to <b>Auto</b> and use the «<b>+</b>» and «<b>-</b>» buttons to change the scale of the worksheet. The borders of the printing page will be covered with dashed lines in the spreadsheet,</li>
                </ul>
            <p><img alt="Scale to fit menu" src="../images/scaletofitlayout.png" /></p>
            </li>
            <li>on the <b>File</b> tab, click <b>Print</b>, or use the keyboard shortcuts Ctrl + P and adjust the print settings in the opened window. For example, if there are many columns in a sheet, it might be useful to change the <b>Page Orientation</b> to <b>Portrait</b>. Or print the <b>pre-selected</b> cell range. Find out more about the print settings in <a href="SavePrintDownload.htm" onclick="onhyperlinkclick(this)">this article</a>.
                <p><img alt="Print settings" src="../images/printsettingswindow.png" /></p>
            </li>
        </ul>
        <p class="note"><b>Note</b>: keep in mind, however, that the printout may be difficult to read because the editor shrinks the data to fit.</p>
    </div>
</body>
</html>